package com.zzj.ecology.system.mapper.system;

import com.zzj.ecology.system.bean.system.SysUrl;
import com.zzj.ecology.system.bean.system.SysUrlExample;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface SysUrlMapper {
    long countByExample(SysUrlExample example);

    int deleteByExample(SysUrlExample example);

    int deleteByPrimaryKey(Integer urlId);

    int insert(SysUrl record);

    int insertSelective(SysUrl record);

    List<SysUrl> selectByExample(SysUrlExample example);

    SysUrl selectByPrimaryKey(Integer urlId);

    int updateByExampleSelective(@Param("record") SysUrl record, @Param("example") SysUrlExample example);

    int updateByExample(@Param("record") SysUrl record, @Param("example") SysUrlExample example);

    int updateByPrimaryKeySelective(SysUrl record);

    int updateByPrimaryKey(SysUrl record);

    /**
     * 分页查询 URL 列表数据
     * @param first
     * @param pageCounts
     * @return
     */
    List<SysUrl> findPageList(Integer first, Integer pageCounts);

    /**
     * 批量修改 delete_status = '0' 修改成 '1', 记录修改人员并且修改时间
     * @param urlIds
     * @param username
     * @return
     */
    int updateDeleteStatusByIds(@Param("ids") List<Integer> urlIds, @Param("updateBy") String username);
}